Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	1048532
Missing cells	2648376
Missing cells (%)	10.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.0 GiB
Average record size in memory	1.0 KiB

Variable types

Numeric	8
Categorical	6
Text	9
DateTime	1

Alerts

`Acceptance Status` is highly overall correlated with `Acceptance to Installation Days` and 6 other fields	High correlation
`Acceptance to Installation Days` is highly overall correlated with `Acceptance Status`	High correlation
`Approval to Vendor Selection Days` is highly overall correlated with `Acceptance Status`	High correlation
`Inspection to Subsidy Redeemed Days` is highly overall correlated with `Acceptance Status`	High correlation
`Installation to Inspection Days` is highly overall correlated with `Acceptance Status`	High correlation
`Registration to Approval Days` is highly overall correlated with `Acceptance Status`	High correlation
`Subsidy Redeemed to Released Days` is highly overall correlated with `Acceptance Status`	High correlation
`Vendor Selection to Acceptance Days` is highly overall correlated with `Acceptance Status`	High correlation
`Registration to Approval Days` has 202247 (19.3%) missing values	Missing
`Approval to Vendor Selection Days` has 233977 (22.3%) missing values	Missing
`Vendor Selection to Acceptance Days` has 284452 (27.1%) missing values	Missing
`Acceptance to Installation Days` has 356903 (34.0%) missing values	Missing
`Installation to Inspection Days` has 436530 (41.6%) missing values	Missing
`Inspection to Subsidy Redeemed Days` has 523090 (49.9%) missing values	Missing
`Subsidy Redeemed to Released Days` has 611177 (58.3%) missing values	Missing
`Application Number` has unique values	Unique

Reproduction

Analysis started	2025-03-27 05:09:23.198827
Analysis finished	2025-03-27 05:10:26.959283
Duration	1 minute and 3.76 seconds
Software version	ydata-profiling vv4.15.1
Download configuration	config.json

Application Number
Real number (ℝ)

Unique

Distinct	1048532
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54955118

Minimum	10000005
Maximum	99999993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	10000005
5-th percentile	14482858
Q1	32490250
median	54924249
Q3	77438318
95-th percentile	95473603
Maximum	99999993
Range	89999988
Interquartile range (IQR)	44948068

Descriptive statistics

Standard deviation	25973624
Coefficient of variation (CV)	0.4726334
Kurtosis	-1.199105
Mean	54955118
Median Absolute Deviation (MAD)	22474760
Skewness	0.0017519428
Sum	5.76222 × 10¹³
Variance	6.7462916 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
87559218	1	< 0.1%
77442871	1	< 0.1%
46760652	1	< 0.1%
50016740	1	< 0.1%
25843214	1	< 0.1%
48994393	1	< 0.1%
63253297	1	< 0.1%
54760876	1	< 0.1%
82219819	1	< 0.1%
73776238	1	< 0.1%
Other values (1048522)	1048522	> 99.9%

Value	Count	Frequency (%)
10000005	1	< 0.1%
10000035	1	< 0.1%
10000114	1	< 0.1%
10000125	1	< 0.1%
10000176	1	< 0.1%
10000184	1	< 0.1%
10000288	1	< 0.1%
10000342	1	< 0.1%
10000536	1	< 0.1%
10000601	1	< 0.1%

Value	Count	Frequency (%)
99999993	1	< 0.1%
99999883	1	< 0.1%
99999822	1	< 0.1%
99999796	1	< 0.1%
99999652	1	< 0.1%
99999627	1	< 0.1%
99999553	1	< 0.1%
99999306	1	< 0.1%
99999282	1	< 0.1%
99999280	1	< 0.1%

Gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.9 MiB

Male	576349
Female	461887
Other	10296

Length

Max length	6
Median length	4
Mean length	4.8908359
Min length	4

Characters and Unicode

Total characters	5128198
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Male
5th row	Female

Common Values

Value	Count	Frequency (%)
Male	576349	55.0%
Female	461887	44.1%
Other	10296	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	576349	55.0%
female	461887	44.1%
other	10296	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	1510419	29.5%
a	1038236	20.2%
l	1038236	20.2%
M	576349	11.2%
F	461887	9.0%
m	461887	9.0%
O	10296	0.2%
t	10296	0.2%
h	10296	0.2%
r	10296	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5128198	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1510419	29.5%
a	1038236	20.2%
l	1038236	20.2%
M	576349	11.2%
F	461887	9.0%
m	461887	9.0%
O	10296	0.2%
t	10296	0.2%
h	10296	0.2%
r	10296	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5128198	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1510419	29.5%
a	1038236	20.2%
l	1038236	20.2%
M	576349	11.2%
F	461887	9.0%
m	461887	9.0%
O	10296	0.2%
t	10296	0.2%
h	10296	0.2%
r	10296	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5128198	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1510419	29.5%
a	1038236	20.2%
l	1038236	20.2%
M	576349	11.2%
F	461887	9.0%
m	461887	9.0%
O	10296	0.2%
t	10296	0.2%
h	10296	0.2%
r	10296	0.2%

State/UT
Categorical

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.0 MiB

Gujarat	197845
Maharashtra	111407
Uttar Pradesh	99415
Rajasthan	83064
Karnataka	60533
Other values (31)	496268

Length

Max length	40
Median length	17
Mean length	9.9951799
Min length	3

Characters and Unicode

Total characters	10480266
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mizoram
2nd row	Maharashtra
3rd row	Madhya Pradesh
4th row	Andhra Pradesh
5th row	Bihar

Common Values

Value	Count	Frequency (%)
Gujarat	197845	18.9%
Maharashtra	111407	10.6%
Uttar Pradesh	99415	9.5%
Rajasthan	83064	7.9%
Karnataka	60533	5.8%
Telangana	59847	5.7%
Andhra Pradesh	58682	5.6%
Madhya Pradesh	39760	3.8%
Tamil Nadu	37071	3.5%
Punjab	21796	2.1%
Other values (26)	279112	26.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	218426	15.4%
gujarat	197845	14.0%
maharashtra	111407	7.9%
uttar	99415	7.0%
rajasthan	83064	5.9%
karnataka	60533	4.3%
telangana	59847	4.2%
andhra	58682	4.1%
and	43185	3.0%
madhya	39760	2.8%
Other values (37)	444759	31.4%

Most occurring characters

Value	Count	Frequency (%)
a	2642015	25.2%
r	1053045	10.0%
h	834529	8.0%
t	733710	7.0%
n	509870	4.9%
s	509351	4.9%
d	502715	4.8%
	368391	3.5%
e	367569	3.5%
u	318701	3.0%
Other values (33)	2640370	25.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10480266	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2642015	25.2%
r	1053045	10.0%
h	834529	8.0%
t	733710	7.0%
n	509870	4.9%
s	509351	4.9%
d	502715	4.8%
	368391	3.5%
e	367569	3.5%
u	318701	3.0%
Other values (33)	2640370	25.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10480266	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2642015	25.2%
r	1053045	10.0%
h	834529	8.0%
t	733710	7.0%
n	509870	4.9%
s	509351	4.9%
d	502715	4.8%
	368391	3.5%
e	367569	3.5%
u	318701	3.0%
Other values (33)	2640370	25.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10480266	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2642015	25.2%
r	1053045	10.0%
h	834529	8.0%
t	733710	7.0%
n	509870	4.9%
s	509351	4.9%
d	502715	4.8%
	368391	3.5%
e	367569	3.5%
u	318701	3.0%
Other values (33)	2640370	25.2%

District
Text

Distinct	733
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.5 MiB

Length

Max length	26
Median length	22
Mean length	8.4649806
Min length	3

Characters and Unicode

Total characters	8875803
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Lunglei
2nd row	Nanded
3rd row	Sehore
4th row	Nellore
5th row	Khagaria

Value	Count	Frequency (%)
north	18529	1.5%
south	17380	1.4%
west	11565	0.9%
east	11374	0.9%
mumbai	10498	0.9%
kheda	10128	0.8%
junagadh	10038	0.8%
kachchh	9990	0.8%
mahisagar	9771	0.8%
jamnagar	9638	0.8%
Other values (736)	1101375	90.3%

Most occurring characters

Value	Count	Frequency (%)
a	1795702	20.2%
r	729274	8.2%
h	554249	6.2%
i	532512	6.0%
n	517513	5.8%
u	427158	4.8%
d	340757	3.8%
o	321708	3.6%
l	314445	3.5%
t	268599	3.0%
Other values (44)	3073886	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8875803	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1795702	20.2%
r	729274	8.2%
h	554249	6.2%
i	532512	6.0%
n	517513	5.8%
u	427158	4.8%
d	340757	3.8%
o	321708	3.6%
l	314445	3.5%
t	268599	3.0%
Other values (44)	3073886	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8875803	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1795702	20.2%
r	729274	8.2%
h	554249	6.2%
i	532512	6.0%
n	517513	5.8%
u	427158	4.8%
d	340757	3.8%
o	321708	3.6%
l	314445	3.5%
t	268599	3.0%
Other values (44)	3073886	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8875803	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1795702	20.2%
r	729274	8.2%
h	554249	6.2%
i	532512	6.0%
n	517513	5.8%
u	427158	4.8%
d	340757	3.8%
o	321708	3.6%
l	314445	3.5%
t	268599	3.0%
Other values (44)	3073886	34.6%

RWA/Residential
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.3 MiB

Residential	831968
RWA	216564

Length

Max length	11
Median length	11
Mean length	9.3476785
Min length	3

Characters and Unicode

Total characters	9801340
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Residential
2nd row	Residential
3rd row	Residential
4th row	Residential
5th row	RWA

Common Values

Value	Count	Frequency (%)
Residential	831968	79.3%
RWA	216564	20.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
residential	831968	79.3%
rwa	216564	20.7%

Most occurring characters

Value	Count	Frequency (%)
e	1663936	17.0%
i	1663936	17.0%
R	1048532	10.7%
s	831968	8.5%
d	831968	8.5%
n	831968	8.5%
t	831968	8.5%
a	831968	8.5%
l	831968	8.5%
W	216564	2.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9801340	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1663936	17.0%
i	1663936	17.0%
R	1048532	10.7%
s	831968	8.5%
d	831968	8.5%
n	831968	8.5%
t	831968	8.5%
a	831968	8.5%
l	831968	8.5%
W	216564	2.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9801340	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1663936	17.0%
i	1663936	17.0%
R	1048532	10.7%
s	831968	8.5%
d	831968	8.5%
n	831968	8.5%
t	831968	8.5%
a	831968	8.5%
l	831968	8.5%
W	216564	2.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9801340	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1663936	17.0%
i	1663936	17.0%
R	1048532	10.7%
s	831968	8.5%
d	831968	8.5%
n	831968	8.5%
t	831968	8.5%
a	831968	8.5%
l	831968	8.5%
W	216564	2.2%

Discom Name
Text

Distinct	56
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	96.6 MiB

Length

Max length	69
Median length	58
Mean length	47.640517
Min length	10

Characters and Unicode

Total characters	49952607
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	National Thermal Power Corporation (NTPC)
2nd row	Maharashtra State Electricity Distribution Company Limited (MSEDCL)
3rd row	Madhya Pradesh Poorv Kshetra Vidyut Vitaran Company Limited
4th row	Andhra Pradesh Central Power Distribution Company Limited
5th row	North Bihar Power Distribution Company Limited (NBPDCL)

Value	Count	Frequency (%)
limited	704098	11.0%
company	441006	6.9%
power	323812	5.1%
corporation	255700	4.0%
distribution	221209	3.5%
electricity	193834	3.0%
of	184636	2.9%
vidyut	167836	2.6%
vij	152926	2.4%
gujarat	152926	2.4%
Other values (125)	3598028	56.3%

Most occurring characters

Value	Count	Frequency (%)
	5347479	10.7%
i	4251037	8.5%
a	3974765	8.0%
t	3296068	6.6%
r	3060770	6.1%
o	2650605	5.3%
n	2288304	4.6%
e	2274327	4.6%
d	1829940	3.7%
m	1712073	3.4%
Other values (41)	19267239	38.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	49952607	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5347479	10.7%
i	4251037	8.5%
a	3974765	8.0%
t	3296068	6.6%
r	3060770	6.1%
o	2650605	5.3%
n	2288304	4.6%
e	2274327	4.6%
d	1829940	3.7%
m	1712073	3.4%
Other values (41)	19267239	38.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	49952607	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5347479	10.7%
i	4251037	8.5%
a	3974765	8.0%
t	3296068	6.6%
r	3060770	6.1%
o	2650605	5.3%
n	2288304	4.6%
e	2274327	4.6%
d	1829940	3.7%
m	1712073	3.4%
Other values (41)	19267239	38.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	49952607	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5347479	10.7%
i	4251037	8.5%
a	3974765	8.0%
t	3296068	6.6%
r	3060770	6.1%
o	2650605	5.3%
n	2288304	4.6%
e	2274327	4.6%
d	1829940	3.7%
m	1712073	3.4%
Other values (41)	19267239	38.6%

Acceptance Status
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

Accepted	876634
Rejected	171898

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	8388256
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Accepted
2nd row	Accepted
3rd row	Accepted
4th row	Accepted
5th row	Accepted

Common Values

Value	Count	Frequency (%)
Accepted	876634	83.6%
Rejected	171898	16.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
accepted	876634	83.6%
rejected	171898	16.4%

Most occurring characters

Value	Count	Frequency (%)
e	2268962	27.0%
c	1925166	23.0%
d	1048532	12.5%
t	1048532	12.5%
p	876634	10.5%
A	876634	10.5%
R	171898	2.0%
j	171898	2.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2268962	27.0%
c	1925166	23.0%
d	1048532	12.5%
t	1048532	12.5%
p	876634	10.5%
A	876634	10.5%
R	171898	2.0%
j	171898	2.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2268962	27.0%
c	1925166	23.0%
d	1048532	12.5%
t	1048532	12.5%
p	876634	10.5%
A	876634	10.5%
R	171898	2.0%
j	171898	2.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2268962	27.0%
c	1925166	23.0%
d	1048532	12.5%
t	1048532	12.5%
p	876634	10.5%
A	876634	10.5%
R	171898	2.0%
j	171898	2.0%

Production Capacity (KW)
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

3 - 4 KW	734297
4 - 5 KW	154161
5 - 6 KW	77084
2 - 3 KW	58091
Above 6 KW	20914

Length

Max length	10
Median length	8
Mean length	8.039892
Min length	8

Characters and Unicode

Total characters	8430084
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3 - 4 KW
2nd row	3 - 4 KW
3rd row	3 - 4 KW
4th row	4 - 5 KW
5th row	3 - 4 KW

Common Values

Value	Count	Frequency (%)
3 - 4 KW	734297	70.0%
4 - 5 KW	154161	14.7%
5 - 6 KW	77084	7.4%
2 - 3 KW	58091	5.5%
Above 6 KW	20914	2.0%
1 - 2 KW	3985	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kw	1048532	25.1%
	1027618	24.6%
4	888458	21.3%
3	792388	19.0%
5	231245	5.5%
6	97998	2.3%
2	62076	1.5%
above	20914	0.5%
1	3985	0.1%

Most occurring characters

Value	Count	Frequency (%)
	3124682	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027618	12.2%
4	888458	10.5%
3	792388	9.4%
5	231245	2.7%
6	97998	1.2%
2	62076	0.7%
A	20914	0.2%
Other values (5)	87641	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8430084	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3124682	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027618	12.2%
4	888458	10.5%
3	792388	9.4%
5	231245	2.7%
6	97998	1.2%
2	62076	0.7%
A	20914	0.2%
Other values (5)	87641	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8430084	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3124682	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027618	12.2%
4	888458	10.5%
3	792388	9.4%
5	231245	2.7%
6	97998	1.2%
2	62076	0.7%
A	20914	0.2%
Other values (5)	87641	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8430084	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3124682	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027618	12.2%
4	888458	10.5%
3	792388	9.4%
5	231245	2.7%
6	97998	1.2%
2	62076	0.7%
A	20914	0.2%
Other values (5)	87641	1.0%

Vendor Organization
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.9 MiB

SkyPower Solar	82321
BrightSun Power	78633
GreenSpark Solar	74320
RadiantSun Energy	74173
SunWave Energy	70074
Other values (15)	669011

Length

Max length	27
Median length	23
Mean length	18.883117
Min length	13

Characters and Unicode

Total characters	19799552
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GreenSpark Solar
2nd row	GreenSpark Solar
3rd row	SolarPeak Innovations
4th row	PowerSun Technologies
5th row	SolarCrest Enterprises

Common Values

Value	Count	Frequency (%)
SkyPower Solar	82321	7.9%
BrightSun Power	78633	7.5%
GreenSpark Solar	74320	7.1%
RadiantSun Energy	74173	7.1%
SunWave Energy	70074	6.7%
SunTech Solar Solutions	65751	6.3%
SunRise Renewable Solutions	61272	5.8%
SolarHarvest Energy	56970	5.4%
SolarPeak Innovations	56690	5.4%
InfiniteLight Solar	52410	5.0%
Other values (10)	375918	35.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
solar	340492	14.8%
energy	232138	10.1%
solutions	157944	6.9%
power	117904	5.1%
systems	105000	4.6%
technologies	96350	4.2%
skypower	82321	3.6%
brightsun	78633	3.4%
enterprises	77977	3.4%
greenspark	74320	3.2%
Other values (19)	931220	40.6%

Most occurring characters

Value	Count	Frequency (%)
e	2010478	10.2%
n	1740615	8.8%
r	1671354	8.4%
o	1551297	7.8%
S	1490014	7.5%
	1245767	6.3%
a	1196665	6.0%
l	1005035	5.1%
t	842754	4.3%
s	838349	4.2%
Other values (26)	6207224	31.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19799552	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2010478	10.2%
n	1740615	8.8%
r	1671354	8.4%
o	1551297	7.8%
S	1490014	7.5%
	1245767	6.3%
a	1196665	6.0%
l	1005035	5.1%
t	842754	4.3%
s	838349	4.2%
Other values (26)	6207224	31.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19799552	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2010478	10.2%
n	1740615	8.8%
r	1671354	8.4%
o	1551297	7.8%
S	1490014	7.5%
	1245767	6.3%
a	1196665	6.0%
l	1005035	5.1%
t	842754	4.3%
s	838349	4.2%
Other values (26)	6207224	31.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19799552	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2010478	10.2%
n	1740615	8.8%
r	1671354	8.4%
o	1551297	7.8%
S	1490014	7.5%
	1245767	6.3%
a	1196665	6.0%
l	1005035	5.1%
t	842754	4.3%
s	838349	4.2%
Other values (26)	6207224	31.4%

Registration Date
Date

Distinct	366
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.0 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Application Approved Date
Text

Distinct	366
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.6 MiB

Length

Max length	10
Median length	10
Mean length	9.585284
Min length	7

Characters and Unicode

Total characters	10050477
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024-11-10
2nd row	2024-02-13
3rd row	2024-04-15
4th row	2024-10-03
5th row	2024-07-08

Value	Count	Frequency (%)
declined	171898	16.4%
pending	30349	2.9%
2024-07-31	4270	0.4%
2024-07-30	4205	0.4%
2024-07-29	4184	0.4%
2024-07-27	4182	0.4%
2024-08-03	4178	0.4%
2024-08-02	4172	0.4%
2024-08-04	4144	0.4%
2024-08-01	4133	0.4%
Other values (356)	812817	77.5%

Most occurring characters

Value	Count	Frequency (%)
2	2184537	21.7%
0	1830490	18.2%
-	1692570	16.8%
4	985968	9.8%
1	750097	7.5%
e	374145	3.7%
n	232596	2.3%
i	202247	2.0%
d	202247	2.0%
7	197347	2.0%
Other values (10)	1398233	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10050477	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	2184537	21.7%
0	1830490	18.2%
-	1692570	16.8%
4	985968	9.8%
1	750097	7.5%
e	374145	3.7%
n	232596	2.3%
i	202247	2.0%
d	202247	2.0%
7	197347	2.0%
Other values (10)	1398233	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10050477	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	2184537	21.7%
0	1830490	18.2%
-	1692570	16.8%
4	985968	9.8%
1	750097	7.5%
e	374145	3.7%
n	232596	2.3%
i	202247	2.0%
d	202247	2.0%
7	197347	2.0%
Other values (10)	1398233	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10050477	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	2184537	21.7%
0	1830490	18.2%
-	1692570	16.8%
4	985968	9.8%
1	750097	7.5%
e	374145	3.7%
n	232596	2.3%
i	202247	2.0%
d	202247	2.0%
7	197347	2.0%
Other values (10)	1398233	13.9%

Vendor Selection Date
Text

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.5 MiB

Length

Max length	10
Median length	10
Mean length	9.4944999
Min length	7

Characters and Unicode

Total characters	9955287
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024-11-21
2nd row	2024-03-21
3rd row	2024-04-21
4th row	2024-10-11
5th row	2024-07-14

Value	Count	Frequency (%)
declined	171898	16.4%
pending	62079	5.9%
2024-08-07	4177	0.4%
2024-08-08	4151	0.4%
2024-08-04	4125	0.4%
2024-08-06	4077	0.4%
2024-08-11	4063	0.4%
2024-08-02	4044	0.4%
2024-08-12	4030	0.4%
2024-08-09	4017	0.4%
Other values (351)	781871	74.6%

Most occurring characters

Value	Count	Frequency (%)
2	2109080	21.2%
0	1758861	17.7%
-	1629110	16.4%
4	947386	9.5%
1	709376	7.1%
e	405875	4.1%
n	296056	3.0%
i	233977	2.4%
d	233977	2.4%
8	192026	1.9%
Other values (10)	1439563	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9955287	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	2109080	21.2%
0	1758861	17.7%
-	1629110	16.4%
4	947386	9.5%
1	709376	7.1%
e	405875	4.1%
n	296056	3.0%
i	233977	2.4%
d	233977	2.4%
8	192026	1.9%
Other values (10)	1439563	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9955287	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	2109080	21.2%
0	1758861	17.7%
-	1629110	16.4%
4	947386	9.5%
1	709376	7.1%
e	405875	4.1%
n	296056	3.0%
i	233977	2.4%
d	233977	2.4%
8	192026	1.9%
Other values (10)	1439563	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9955287	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	2109080	21.2%
0	1758861	17.7%
-	1629110	16.4%
4	947386	9.5%
1	709376	7.1%
e	405875	4.1%
n	296056	3.0%
i	233977	2.4%
d	233977	2.4%
8	192026	1.9%
Other values (10)	1439563	14.5%

Vendor Acceptance Date
Text

Distinct	356
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.3 MiB

Length

Max length	10
Median length	10
Mean length	9.3500837
Min length	7

Characters and Unicode

Total characters	9803862
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2024-11-30
2nd row	2024-04-15
3rd row	2024-04-26
4th row	2024-10-16
5th row	2024-07-22

Value	Count	Frequency (%)
declined	171898	16.4%
pending	112554	10.7%
2024-08-15	3799	0.4%
2024-08-18	3755	0.4%
2024-08-19	3754	0.4%
2024-08-16	3719	0.4%
2024-08-20	3708	0.4%
2024-08-14	3702	0.4%
2024-08-17	3686	0.4%
2024-08-21	3685	0.4%
Other values (346)	734272	70.0%

Most occurring characters

Value	Count	Frequency (%)
2	1973730	20.1%
0	1646747	16.8%
-	1528160	15.6%
4	886741	9.0%
1	667109	6.8%
e	456350	4.7%
n	397006	4.0%
i	284452	2.9%
d	284452	2.9%
8	185320	1.9%
Other values (10)	1493795	15.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9803862	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1973730	20.1%
0	1646747	16.8%
-	1528160	15.6%
4	886741	9.0%
1	667109	6.8%
e	456350	4.7%
n	397006	4.0%
i	284452	2.9%
d	284452	2.9%
8	185320	1.9%
Other values (10)	1493795	15.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9803862	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1973730	20.1%
0	1646747	16.8%
-	1528160	15.6%
4	886741	9.0%
1	667109	6.8%
e	456350	4.7%
n	397006	4.0%
i	284452	2.9%
d	284452	2.9%
8	185320	1.9%
Other values (10)	1493795	15.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9803862	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1973730	20.1%
0	1646747	16.8%
-	1528160	15.6%
4	886741	9.0%
1	667109	6.8%
e	456350	4.7%
n	397006	4.0%
i	284452	2.9%
d	284452	2.9%
8	185320	1.9%
Other values (10)	1493795	15.2%

Installation Date
Text

Distinct	349
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.1 MiB

Length

Max length	10
Median length	10
Mean length	9.1427911
Min length	7

Characters and Unicode

Total characters	9586509
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2024-12-23
2nd row	2024-05-31
3rd row	2024-05-16
4th row	2024-11-06
5th row	2024-08-14

Value	Count	Frequency (%)
pending	185005	17.6%
declined	171898	16.4%
2024-09-10	3548	0.3%
2024-09-11	3537	0.3%
2024-09-16	3525	0.3%
2024-09-07	3518	0.3%
2024-09-06	3511	0.3%
2024-09-13	3508	0.3%
2024-08-31	3487	0.3%
2024-09-05	3480	0.3%
Other values (339)	663515	63.3%

Most occurring characters

Value	Count	Frequency (%)
2	1775018	18.5%
0	1485013	15.5%
-	1383258	14.4%
4	798165	8.3%
1	632158	6.6%
n	541908	5.7%
e	528801	5.5%
d	356903	3.7%
i	356903	3.7%
P	185005	1.9%
Other values (10)	1543377	16.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9586509	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1775018	18.5%
0	1485013	15.5%
-	1383258	14.4%
4	798165	8.3%
1	632158	6.6%
n	541908	5.7%
e	528801	5.5%
d	356903	3.7%
i	356903	3.7%
P	185005	1.9%
Other values (10)	1543377	16.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9586509	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1775018	18.5%
0	1485013	15.5%
-	1383258	14.4%
4	798165	8.3%
1	632158	6.6%
n	541908	5.7%
e	528801	5.5%
d	356903	3.7%
i	356903	3.7%
P	185005	1.9%
Other values (10)	1543377	16.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9586509	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1775018	18.5%
0	1485013	15.5%
-	1383258	14.4%
4	798165	8.3%
1	632158	6.6%
n	541908	5.7%
e	528801	5.5%
d	356903	3.7%
i	356903	3.7%
P	185005	1.9%
Other values (10)	1543377	16.1%

Inspection Date
Text

Distinct	340
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.9 MiB

Length

Max length	10
Median length	10
Mean length	8.9149668
Min length	7

Characters and Unicode

Total characters	9347628
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Pending
2nd row	2024-06-24
3rd row	2024-06-28
4th row	2024-11-28
5th row	2024-09-02

Value	Count	Frequency (%)
pending	264632	25.2%
declined	171898	16.4%
2024-10-06	3303	0.3%
2024-10-01	3264	0.3%
2024-10-04	3257	0.3%
2024-10-07	3245	0.3%
2024-10-10	3243	0.3%
2024-10-03	3221	0.3%
2024-10-02	3204	0.3%
2024-10-14	3203	0.3%
Other values (330)	586062	55.9%

Most occurring characters

Value	Count	Frequency (%)
2	1573492	16.8%
0	1291123	13.8%
-	1224004	13.1%
n	701162	7.5%
4	696249	7.4%
1	616337	6.6%
e	608428	6.5%
d	436530	4.7%
i	436530	4.7%
P	264632	2.8%
Other values (10)	1499141	16.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9347628	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1573492	16.8%
0	1291123	13.8%
-	1224004	13.1%
n	701162	7.5%
4	696249	7.4%
1	616337	6.6%
e	608428	6.5%
d	436530	4.7%
i	436530	4.7%
P	264632	2.8%
Other values (10)	1499141	16.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9347628	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1573492	16.8%
0	1291123	13.8%
-	1224004	13.1%
n	701162	7.5%
4	696249	7.4%
1	616337	6.6%
e	608428	6.5%
d	436530	4.7%
i	436530	4.7%
P	264632	2.8%
Other values (10)	1499141	16.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9347628	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1573492	16.8%
0	1291123	13.8%
-	1224004	13.1%
n	701162	7.5%
4	696249	7.4%
1	616337	6.6%
e	608428	6.5%
d	436530	4.7%
i	436530	4.7%
P	264632	2.8%
Other values (10)	1499141	16.0%

Subsidy Redeemed Date
Text

Distinct	326
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.7 MiB

Length

Max length	10
Median length	10
Mean length	8.6673063
Min length	7

Characters and Unicode

Total characters	9087948
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Pending
2nd row	2024-07-12
3rd row	2024-07-21
4th row	Pending
5th row	2024-09-25

Value	Count	Frequency (%)
pending	351192	33.5%
declined	171898	16.4%
2024-10-26	3106	0.3%
2024-11-01	3099	0.3%
2024-11-02	3095	0.3%
2024-11-05	3089	0.3%
2024-11-17	3088	0.3%
2024-11-18	3079	0.3%
2024-11-22	3073	0.3%
2024-11-13	3069	0.3%
Other values (316)	500744	47.8%

Most occurring characters

Value	Count	Frequency (%)
2	1367797	15.1%
0	1072852	11.8%
-	1050884	11.6%
n	874282	9.6%
e	694988	7.6%
1	588231	6.5%
4	586717	6.5%
d	523090	5.8%
i	523090	5.8%
P	351192	3.9%
Other values (10)	1454825	16.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9087948	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1367797	15.1%
0	1072852	11.8%
-	1050884	11.6%
n	874282	9.6%
e	694988	7.6%
1	588231	6.5%
4	586717	6.5%
d	523090	5.8%
i	523090	5.8%
P	351192	3.9%
Other values (10)	1454825	16.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9087948	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1367797	15.1%
0	1072852	11.8%
-	1050884	11.6%
n	874282	9.6%
e	694988	7.6%
1	588231	6.5%
4	586717	6.5%
d	523090	5.8%
i	523090	5.8%
P	351192	3.9%
Other values (10)	1454825	16.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9087948	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1367797	15.1%
0	1072852	11.8%
-	1050884	11.6%
n	874282	9.6%
e	694988	7.6%
1	588231	6.5%
4	586717	6.5%
d	523090	5.8%
i	523090	5.8%
P	351192	3.9%
Other values (10)	1454825	16.0%

Subsidy Released Date
Text

Distinct	310
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

Length

Max length	10
Median length	8
Mean length	8.4152768
Min length	7

Characters and Unicode

Total characters	8823687
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Pending
2nd row	2024-09-04
3rd row	2024-08-12
4th row	Pending
5th row	2024-10-15

Value	Count	Frequency (%)
pending	439279	41.9%
declined	171898	16.4%
2024-12-15	3001	0.3%
2024-11-21	3001	0.3%
2024-12-09	2993	0.3%
2024-12-06	2987	0.3%
2024-12-18	2985	0.3%
2024-12-13	2980	0.3%
2024-12-12	2972	0.3%
2024-12-08	2962	0.3%
Other values (300)	413474	39.4%

Most occurring characters

Value	Count	Frequency (%)
2	1157258	13.1%
n	1050456	11.9%
-	874710	9.9%
0	863489	9.8%
e	783075	8.9%
d	611177	6.9%
i	611177	6.9%
1	527149	6.0%
4	483310	5.5%
P	439279	5.0%
Other values (10)	1422607	16.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8823687	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1157258	13.1%
n	1050456	11.9%
-	874710	9.9%
0	863489	9.8%
e	783075	8.9%
d	611177	6.9%
i	611177	6.9%
1	527149	6.0%
4	483310	5.5%
P	439279	5.0%
Other values (10)	1422607	16.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8823687	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1157258	13.1%
n	1050456	11.9%
-	874710	9.9%
0	863489	9.8%
e	783075	8.9%
d	611177	6.9%
i	611177	6.9%
1	527149	6.0%
4	483310	5.5%
P	439279	5.0%
Other values (10)	1422607	16.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8823687	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1157258	13.1%
n	1050456	11.9%
-	874710	9.9%
0	863489	9.8%
e	783075	8.9%
d	611177	6.9%
i	611177	6.9%
1	527149	6.0%
4	483310	5.5%
P	439279	5.0%
Other values (10)	1422607	16.1%

Registration to Approval Days
Real number (ℝ)

High correlation Missing

Distinct	57
Distinct (%)	< 0.1%
Missing	202247
Missing (%)	19.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.434802

Minimum	2
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	7
median	9
Q3	12
95-th percentile	27
Maximum	60
Range	58
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	9.0840534
Coefficient of variation (CV)	0.73053465
Kurtosis	5.6343844
Mean	12.434802
Median Absolute Deviation (MAD)	2
Skewness	2.2773818
Sum	10523386
Variance	82.520026
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	111789	10.7%
8	111753	10.7%
7	93993	9.0%
10	93034	8.9%
6	65607	6.3%
11	64454	6.1%
5	38422	3.7%
12	37214	3.5%
23	23567	2.2%
24	23378	2.2%
Other values (47)	183074	17.5%
(Missing)	202247	19.3%

Value	Count	Frequency (%)
2	2609	0.2%
3	7492	0.7%
4	18510	1.8%
5	38422	3.7%
6	65607	6.3%
7	93993	9.0%
8	111753	10.7%
9	111789	10.7%
10	93034	8.9%
11	64454	6.1%

Value	Count	Frequency (%)
60	38	< 0.1%
59	73	< 0.1%
58	105	< 0.1%
57	180	< 0.1%
56	326	< 0.1%
55	429	< 0.1%
54	675	0.1%
53	918	0.1%
52	1183	0.1%
51	1554	0.1%

Approval to Vendor Selection Days
Real number (ℝ)

High correlation Missing

Distinct	57
Distinct (%)	< 0.1%
Missing	233977
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.522979

Minimum	2
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	7
median	9
Q3	15
95-th percentile	26
Maximum	60
Range	58
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.8732403
Coefficient of variation (CV)	0.62870348
Kurtosis	3.5165425
Mean	12.522979
Median Absolute Deviation (MAD)	2
Skewness	1.6787273
Sum	10200655
Variance	61.987913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	102244	9.8%
8	102064	9.7%
7	85057	8.1%
10	84694	8.1%
6	59609	5.7%
11	58698	5.6%
5	34854	3.3%
12	33850	3.2%
23	31745	3.0%
24	31635	3.0%
Other values (47)	190105	18.1%
(Missing)	233977	22.3%

Value	Count	Frequency (%)
2	2309	0.2%
3	6706	0.6%
4	17116	1.6%
5	34854	3.3%
6	59609	5.7%
7	85057	8.1%
8	102064	9.7%
9	102244	9.8%
10	84694	8.1%
11	58698	5.6%

Value	Count	Frequency (%)
60	12	< 0.1%
59	23	< 0.1%
58	48	< 0.1%
57	50	< 0.1%
56	86	< 0.1%
55	162	< 0.1%
54	239	< 0.1%
53	349	< 0.1%
52	420	< 0.1%
51	540	0.1%

Vendor Selection to Acceptance Days
Real number (ℝ)

High correlation Missing

Distinct	57
Distinct (%)	< 0.1%
Missing	284452
Missing (%)	27.1%
Infinite	0
Infinite (%)	0.0%
Mean	17.060108

Minimum	2
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	8
median	11
Q3	24
95-th percentile	47
Maximum	60
Range	58
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.650349
Coefficient of variation (CV)	0.74151638
Kurtosis	0.89164051
Mean	17.060108
Median Absolute Deviation (MAD)	5
Skewness	1.315442
Sum	13035287
Variance	160.03134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	76450	7.3%
8	76402	7.3%
7	64313	6.1%
10	63454	6.1%
6	44779	4.3%
11	43997	4.2%
23	35812	3.4%
24	35810	3.4%
22	30201	2.9%
25	29512	2.8%
Other values (47)	263350	25.1%
(Missing)	284452	27.1%

Value	Count	Frequency (%)
2	1710	0.2%
3	5267	0.5%
4	12781	1.2%
5	25945	2.5%
6	44779	4.3%
7	64313	6.1%
8	76402	7.3%
9	76450	7.3%
10	63454	6.1%
11	43997	4.2%

Value	Count	Frequency (%)
60	97	< 0.1%
59	188	< 0.1%
58	332	< 0.1%
57	562	0.1%
56	864	0.1%
55	1287	0.1%
54	1829	0.2%
53	2516	0.2%
52	3338	0.3%
51	4173	0.4%

Acceptance to Installation Days
Real number (ℝ)

High correlation Missing

Distinct	163
Distinct (%)	< 0.1%
Missing	356903
Missing (%)	34.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.013689

Minimum	2
Maximum	176
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	19
median	23
Q3	26
95-th percentile	49
Maximum	176
Range	174
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	14.256826
Coefficient of variation (CV)	0.59369577
Kurtosis	8.9037996
Mean	24.013689
Median Absolute Deviation (MAD)	3
Skewness	2.1594743
Sum	16608564
Variance	203.25708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	71722	6.8%
24	71007	6.8%
22	60127	5.7%
25	59119	5.6%
21	41617	4.0%
26	41029	3.9%
8	26932	2.6%
9	26522	2.5%
20	24585	2.3%
27	23692	2.3%
Other values (153)	245277	23.4%
(Missing)	356903	34.0%

Value	Count	Frequency (%)
2	630	0.1%
3	1896	0.2%
4	4490	0.4%
5	9185	0.9%
6	15681	1.5%
7	22407	2.1%
8	26932	2.6%
9	26522	2.5%
10	22201	2.1%
11	15679	1.5%

Value	Count	Frequency (%)
176	2	< 0.1%
174	1	< 0.1%
173	1	< 0.1%
172	1	< 0.1%
171	2	< 0.1%
169	1	< 0.1%
168	1	< 0.1%
167	3	< 0.1%
166	3	< 0.1%
165	3	< 0.1%

Installation to Inspection Days
Real number (ℝ)

High correlation Missing

Distinct	172
Distinct (%)	< 0.1%
Missing	436530
Missing (%)	41.6%
Infinite	0
Infinite (%)	0.0%
Mean	27.664589

Minimum	2
Maximum	178
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	6
Q1	13
median	23
Q3	28
95-th percentile	81
Maximum	178
Range	176
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	20.649017
Coefficient of variation (CV)	0.74640605
Kurtosis	4.921918
Mean	27.664589
Median Absolute Deviation (MAD)	6
Skewness	1.9822545
Sum	16930784
Variance	426.3819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	51666	4.9%
24	51532	4.9%
22	43661	4.2%
25	43083	4.1%
21	30406	2.9%
26	29699	2.8%
8	26194	2.5%
9	26087	2.5%
10	21740	2.1%
7	21674	2.1%
Other values (162)	266260	25.4%
(Missing)	436530	41.6%

Value	Count	Frequency (%)
2	582	0.1%
3	1699	0.2%
4	4322	0.4%
5	9086	0.9%
6	15432	1.5%
7	21674	2.1%
8	26194	2.5%
9	26087	2.5%
10	21740	2.1%
11	14943	1.4%

Value	Count	Frequency (%)
178	2	< 0.1%
176	2	< 0.1%
175	1	< 0.1%
174	2	< 0.1%
173	1	< 0.1%
172	6	< 0.1%
171	3	< 0.1%
170	3	< 0.1%
169	3	< 0.1%
168	9	< 0.1%

Inspection to Subsidy Redeemed Days
Real number (ℝ)

High correlation Missing

Distinct	165
Distinct (%)	< 0.1%
Missing	523090
Missing (%)	49.9%
Infinite	0
Infinite (%)	0.0%
Mean	30.546022

Minimum	2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	21
median	25
Q3	44
95-th percentile	56
Maximum	177
Range	175
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	19.530587
Coefficient of variation (CV)	0.63938235
Kurtosis	3.8505125
Mean	30.546022
Median Absolute Deviation (MAD)	14
Skewness	1.5050302
Sum	16050163
Variance	381.44385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	38425	3.7%
24	38319	3.7%
22	32367	3.1%
25	31808	3.0%
21	22517	2.1%
26	22244	2.1%
8	17662	1.7%
9	17399	1.7%
7	14856	1.4%
10	14645	1.4%
Other values (155)	275200	26.2%
(Missing)	523090	49.9%

Value	Count	Frequency (%)
2	398	< 0.1%
3	1241	0.1%
4	2967	0.3%
5	6185	0.6%
6	10256	1.0%
7	14856	1.4%
8	17662	1.7%
9	17399	1.7%
10	14645	1.4%
11	10076	1.0%

Value	Count	Frequency (%)
177	2	< 0.1%
176	1	< 0.1%
175	2	< 0.1%
174	2	< 0.1%
173	1	< 0.1%
172	4	< 0.1%
171	5	< 0.1%
169	5	< 0.1%
168	11	< 0.1%
167	6	< 0.1%

Subsidy Redeemed to Released Days
Real number (ℝ)

High correlation Missing

Distinct	176
Distinct (%)	< 0.1%
Missing	611177
Missing (%)	58.3%
Infinite	0
Infinite (%)	0.0%
Mean	28.417352

Minimum	2
Maximum	181
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	20
median	24
Q3	39
95-th percentile	53
Maximum	181
Range	179
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	19.475539
Coefficient of variation (CV)	0.6853397
Kurtosis	10.695776
Mean	28.417352
Median Absolute Deviation (MAD)	5
Skewness	2.5047558
Sum	12428471
Variance	379.29664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	38483	3.7%
24	38328	3.7%
22	32339	3.1%
25	31533	3.0%
21	23022	2.2%
26	21888	2.1%
8	14679	1.4%
9	14409	1.4%
20	13313	1.3%
27	12620	1.2%
Other values (166)	196741	18.8%
(Missing)	611177	58.3%

Value	Count	Frequency (%)
2	334	< 0.1%
3	928	0.1%
4	2497	0.2%
5	5051	0.5%
6	8589	0.8%
7	12264	1.2%
8	14679	1.4%
9	14409	1.4%
10	12303	1.2%
11	8488	0.8%

Value	Count	Frequency (%)
181	1	< 0.1%
180	3	< 0.1%
179	2	< 0.1%
178	3	< 0.1%
177	2	< 0.1%
176	5	< 0.1%
175	3	< 0.1%
174	7	< 0.1%
173	10	< 0.1%
172	12	< 0.1%

Interactions

Correlations

	Acceptance Status	Acceptance to Installation Days	Application Number	Approval to Vendor Selection Days	Gender	Inspection to Subsidy Redeemed Days	Installation to Inspection Days	Production Capacity (KW)	RWA/Residential	Registration to Approval Days	State/UT	Subsidy Redeemed to Released Days	Vendor Organization	Vendor Selection to Acceptance Days
Acceptance Status	1.000	1.000	0.000	1.000	0.002	1.000	1.000	0.000	0.004	1.000	0.169	1.000	0.000	1.000
Acceptance to Installation Days	1.000	1.000	0.000	0.001	0.003	-0.008	-0.004	0.000	0.002	0.001	0.002	-0.011	0.001	0.001
Application Number	0.000	0.000	1.000	0.001	0.001	0.002	0.001	0.001	0.002	0.002	0.001	0.002	0.000	-0.000
Approval to Vendor Selection Days	1.000	0.001	0.001	1.000	0.001	-0.004	-0.003	0.000	0.002	-0.001	0.002	-0.005	0.001	-0.001
Gender	0.002	0.003	0.001	0.001	1.000	0.002	0.002	0.001	0.001	0.001	0.000	0.000	0.000	0.000
Inspection to Subsidy Redeemed Days	1.000	-0.008	0.002	-0.004	0.002	1.000	-0.015	0.002	0.002	-0.004	0.002	-0.018	0.000	-0.008
Installation to Inspection Days	1.000	-0.004	0.001	-0.003	0.002	-0.015	1.000	0.000	0.000	-0.003	0.000	-0.016	0.001	-0.005
Production Capacity (KW)	0.000	0.000	0.001	0.000	0.001	0.002	0.000	1.000	0.000	0.001	0.002	0.003	0.000	0.000
RWA/Residential	0.004	0.002	0.002	0.002	0.001	0.002	0.000	0.000	1.000	0.001	0.081	0.005	0.000	0.001
Registration to Approval Days	1.000	0.001	0.002	-0.001	0.001	-0.004	-0.003	0.001	0.001	1.000	0.000	-0.008	0.001	-0.000
State/UT	0.169	0.002	0.001	0.002	0.000	0.002	0.000	0.002	0.081	0.000	1.000	0.003	0.000	0.000
Subsidy Redeemed to Released Days	1.000	-0.011	0.002	-0.005	0.000	-0.018	-0.016	0.003	0.005	-0.008	0.003	1.000	0.002	-0.014
Vendor Organization	0.000	0.001	0.000	0.001	0.000	0.000	0.001	0.000	0.000	0.001	0.000	0.002	1.000	0.000
Vendor Selection to Acceptance Days	1.000	0.001	-0.000	-0.001	0.000	-0.008	-0.005	0.000	0.001	-0.000	0.000	-0.014	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Application Number	Gender	State/UT	District	RWA/Residential	Discom Name	Acceptance Status	Production Capacity (KW)	Vendor Organization	Registration Date	Application Approved Date	Vendor Selection Date	Vendor Acceptance Date	Installation Date	Inspection Date	Subsidy Redeemed Date	Subsidy Released Date	Registration to Approval Days	Approval to Vendor Selection Days	Vendor Selection to Acceptance Days	Acceptance to Installation Days	Installation to Inspection Days	Inspection to Subsidy Redeemed Days	Subsidy Redeemed to Released Days
0	77442871	Female	Mizoram	Lunglei	Residential	National Thermal Power Corporation (NTPC)	Accepted	3 - 4 KW	GreenSpark Solar	2024-11-03	2024-11-10	2024-11-21	2024-11-30	2024-12-23	Pending	Pending	Pending	8.0	12.0	10.0	24.0	NaN	NaN	NaN
1	46760652	Female	Maharashtra	Nanded	Residential	Maharashtra State Electricity Distribution Company Limited (MSEDCL)	Accepted	3 - 4 KW	GreenSpark Solar	2024-02-08	2024-02-13	2024-03-21	2024-04-15	2024-05-31	2024-06-24	2024-07-12	2024-09-04	6.0	38.0	26.0	47.0	25.0	19.0	55.0
2	50016740	Female	Madhya Pradesh	Sehore	Residential	Madhya Pradesh Poorv Kshetra Vidyut Vitaran Company Limited	Accepted	3 - 4 KW	SolarPeak Innovations	2024-04-05	2024-04-15	2024-04-21	2024-04-26	2024-05-16	2024-06-28	2024-07-21	2024-08-12	11.0	7.0	6.0	21.0	44.0	24.0	23.0
3	13098830	Male	Andhra Pradesh	Nellore	Residential	Andhra Pradesh Central Power Distribution Company Limited	Accepted	4 - 5 KW	PowerSun Technologies	2024-09-27	2024-10-03	2024-10-11	2024-10-16	2024-11-06	2024-11-28	Pending	Pending	7.0	9.0	6.0	22.0	23.0	NaN	NaN
4	62980262	Female	Bihar	Khagaria	RWA	North Bihar Power Distribution Company Limited (NBPDCL)	Accepted	3 - 4 KW	SolarCrest Enterprises	2024-06-29	2024-07-08	2024-07-14	2024-07-22	2024-08-14	2024-09-02	2024-09-25	2024-10-15	10.0	7.0	9.0	24.0	20.0	24.0	21.0
5	50072448	Male	Maharashtra	Hingoli	Residential	Maharashtra State Electricity Distribution Company Limited (MSEDCL)	Accepted	3 - 4 KW	BrightSun Power	2024-07-14	2024-07-18	2024-07-29	2024-09-21	2024-10-01	2024-11-13	2024-12-22	2024-12-31	5.0	12.0	55.0	11.0	44.0	40.0	10.0
6	25621825	Male	Sikkim	East Sikkim	RWA	PowerGrid Corporation of India	Accepted	3 - 4 KW	IlluminateSun Technologies	2024-12-17	2024-12-24	Pending	Pending	Pending	Pending	Pending	Pending	8.0	NaN	NaN	NaN	NaN	NaN	NaN
7	60826911	Male	Odisha	Kandhamal	Residential	Southern Electricity Supply Company of Odisha (SOUTHCO)	Accepted	3 - 4 KW	SolarHarvest Energy	2024-03-12	2024-04-03	2024-04-21	2024-05-02	2024-05-08	2024-06-24	2024-08-06	2024-08-29	23.0	19.0	12.0	7.0	48.0	44.0	24.0
8	13990366	Female	Andhra Pradesh	Srikakulam	Residential	Andhra Pradesh Eastern Power Distribution Company Limited	Accepted	3 - 4 KW	GreenSpark Solar	2024-07-01	2024-07-09	2024-07-29	2024-08-25	2024-09-03	2024-09-14	2024-10-09	2024-11-01	9.0	21.0	28.0	10.0	12.0	26.0	24.0
9	63207356	Female	Tamil Nadu	Mayiladuthurai	Residential	Tamil Nadu Generation and Distribution Corporation Limited (TANGEDCO)	Accepted	3 - 4 KW	SolarCrest Enterprises	2024-03-28	2024-04-08	2024-04-12	2024-04-18	2024-05-25	2024-06-15	2024-07-29	2024-09-09	12.0	5.0	7.0	38.0	22.0	45.0	43.0

	Application Number	Gender	State/UT	District	RWA/Residential	Discom Name	Acceptance Status	Production Capacity (KW)	Vendor Organization	Registration Date	Application Approved Date	Vendor Selection Date	Vendor Acceptance Date	Installation Date	Inspection Date	Subsidy Redeemed Date	Subsidy Released Date	Registration to Approval Days	Approval to Vendor Selection Days	Vendor Selection to Acceptance Days	Acceptance to Installation Days	Installation to Inspection Days	Inspection to Subsidy Redeemed Days	Subsidy Redeemed to Released Days
1048522	54548938	Female	Rajasthan	Baran	RWA	Jodhpur Vidyut Vitran Nigam Limited (JdVVNL)	Rejected	3 - 4 KW	IlluminateSun Technologies	2024-03-08	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048523	96025358	Female	Uttar Pradesh	Mirzapur	RWA	Lucknow Electricity Supply Administration (LESA), Lucknow City	Accepted	2 - 3 KW	GreenSpark Solar	2024-12-01	2024-12-10	2024-12-14	Pending	Pending	Pending	Pending	Pending	10.0	5.0	NaN	NaN	NaN	NaN	NaN
1048524	64655782	Female	Tamil Nadu	Tenkasi	RWA	Tamil Nadu Generation and Distribution Corporation Limited (TANGEDCO)	Accepted	5 - 6 KW	GreenSpark Solar	2024-03-18	2024-03-27	2024-04-01	2024-04-06	2024-05-20	2024-06-09	2024-07-24	2024-08-13	10.0	6.0	6.0	45.0	21.0	46.0	21.0
1048525	94327640	Male	Maharashtra	Parbhani	Residential	Tata Power	Accepted	3 - 4 KW	SolarEdge Systems	2024-11-18	2024-11-23	2024-11-30	2024-12-25	Pending	Pending	Pending	Pending	6.0	8.0	26.0	NaN	NaN	NaN	NaN
1048526	52084659	Female	Madhya Pradesh	Sehore	Residential	Madhya Pradesh Poorv Kshetra Vidyut Vitaran Company Limited	Accepted	4 - 5 KW	PowerSun Technologies	2024-02-25	2024-03-04	2024-03-08	2024-04-02	2024-04-23	2024-07-12	2024-08-26	2024-11-23	9.0	5.0	26.0	22.0	81.0	46.0	90.0
1048527	69494107	Female	Telangana	Nagarkurnool	Residential	Northern Power Distribution Company of Telangana Limited (TSNPDCL)	Accepted	3 - 4 KW	RadiantSun Energy	2024-02-18	2024-02-27	2024-03-05	2024-04-16	2024-05-23	2024-06-08	2024-06-27	2024-07-17	10.0	8.0	43.0	38.0	17.0	20.0	21.0
1048528	63201035	Female	Meghalaya	West Khasi Hills	Residential	PowerGrid Corporation of India	Accepted	3 - 4 KW	SunBeam Energy Solutions	2024-11-04	2024-11-10	2024-11-16	2024-11-24	2024-12-14	Pending	Pending	Pending	7.0	7.0	9.0	21.0	NaN	NaN	NaN
1048529	62238278	Female	Uttar Pradesh	Bhadohi	RWA	Pashchimanchal Vidyut Vitran Nigam Limited (PVVNL), Meerut Zone	Rejected	3 - 4 KW	InfiniteLight Solar	2024-01-26	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048530	11048201	Female	Gujarat	Aravalli	Residential	Torrent Power Limited, Ahmedabad	Rejected	Above 6 KW	SunWave Energy	2024-02-17	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048531	87559218	Male	Gujarat	Mehsana	Residential	Madhya Gujarat Vij Company Limited (MGVCL), Vadodara	Rejected	3 - 4 KW	SolarEdge Systems	2024-12-13	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)